SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=12 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+free ad +posting +sites +list' IN BOOLEAN MODE)) AND iCityID IN (4687,4747,4760,4555,4699,4615,4604,4598,4733,4676,4776,4710,4688,4644,4678,4684,4581,4685,4661,4626,4605,4625,4753,4691,4624,4754,4696,4671,4677,4594,4621,4559,4690,4649,4711,4653,4556,4731,4673,4729,4717,4575,4656,4745,4580,4708,4632,4618,4634,4689,4737,4715,4657) ORDER BY FIELD(iCityID, 4687,4747,4760,4555,4699,4615,4604,4598,4733,4676,4776,4710,4688,4644,4678,4684,4581,4685,4661,4626,4605,4625,4753,4691,4624,4754,4696,4671,4677,4594,4621,4559,4690,4649,4711,4653,4556,4731,4673,4729,4717,4575,4656,4745,4580,4708,4632,4618,4634,4689,4737,4715,4657) ASC, p.tmPosted DESC LIMIT 24
free ad posting sites list, Community Classifieds, Local Events, Friends, Activities in Nichols Hills
